Skip to main content

CEILING

Rounds a number up to the nearest multiple of specified significance.

Syntax​

CEILING(number, significance)

Arguments​

  • number: The numeric value you want to round up.
  • significance: The multiple to which you want to round.

Example​

CEILING(123.456, 1) → Returns 124
CEILING(123.456, 0.1) → Returns 123.5
CEILING(123.456, 10) → Returns 130